drop table if exists jms_ods.tab_aviation_send_record ;
create EXTERNAL TABLE if not exists jms_ods.tab_aviation_send_record(
booking_space_no  bigint  comment "订舱号",
send_scan_time  timestamp  comment "航空发件扫描时间",
collect_time  timestamp  comment "揽收时间",
pick_network_name  string  comment "订单所属网点",
pick_network_code  string  comment "订单所属网点code",
pick_network_id  bigint  comment "订单所属网点id",
pick_agent_area_name  string  comment "订单所属代理区",
waybill_no  string  comment "运单号"
)
    COMMENT  '航空发件扫描表'
    PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/tab_aviation_send_record'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

msck repair table jms_ods.tab_aviation_send_record ;
